Overview

Brought to you by YData

Dataset statistics

Number of variables16
Number of observations19359
Missing cells13470
Missing cells (%)4.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory26.7 MiB
Average record size in memory1.4 KiB

Variable types

Text14
Numeric2

Alerts

desc_problema_translated has 543 (2.8%) missing values Missing
descripcion_translated has 3752 (19.4%) missing values Missing
CAR4 has 9174 (47.4%) missing values Missing
id_pieza has unique values Unique

Reproduction

Analysis started2024-12-29 10:09:49.965068
Analysis finished2024-12-29 10:09:53.562379
Duration3.6 seconds
Software versionydata-profiling vv4.12.1
Download configurationconfig.json

Variables

codigo
Text

Distinct15226
Distinct (%)78.7%
Missing0
Missing (%)0.0%
Memory size1.2 MiB
2024-12-29T11:09:53.785724image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length10
Median length10
Mean length10
Min length10

Characters and Unicode

Total characters193590
Distinct characters36
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique13191 ?
Unique (%)68.1%

Sample

1st rowMMZPL2LO50
2nd rowMMZPL2LO50
3rd rowMMZPL2LO50
4th rowL2VQL2LVF3
5th rowLGRPLMLUAE
ValueCountFrequency (%)
ljgbmptkdd 30
 
0.2%
ljgwljdh31 27
 
0.1%
agxlzwoxb3 25
 
0.1%
bgtta2lw64 24
 
0.1%
zmtlz2sy49 24
 
0.1%
ag1jyggzba 23
 
0.1%
zmdpzwmcb8 22
 
0.1%
zwliymcc1b 22
 
0.1%
awdpywcv33 21
 
0.1%
zmpoa2zvdc 20
 
0.1%
Other values (15216) 19121
98.8%
2024-12-29T11:09:54.194304image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
M 16536
 
8.5%
Z 13193
 
6.8%
A 11705
 
6.0%
L 11297
 
5.8%
W 9959
 
5.1%
2 9278
 
4.8%
G 9016
 
4.7%
B 8130
 
4.2%
P 7863
 
4.1%
5 6315
 
3.3%
Other values (26) 90298
46.6%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 155220
80.2%
Decimal Number 38370
 
19.8%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
M 16536
 
10.7%
Z 13193
 
8.5%
A 11705
 
7.5%
L 11297
 
7.3%
W 9959
 
6.4%
G 9016
 
5.8%
B 8130
 
5.2%
P 7863
 
5.1%
N 6016
 
3.9%
D 5933
 
3.8%
Other values (16) 55572
35.8%
Decimal Number
ValueCountFrequency (%)
2 9278
24.2%
5 6315
16.5%
1 4776
12.4%
9 3162
 
8.2%
3 2640
 
6.9%
4 2507
 
6.5%
7 2475
 
6.5%
8 2439
 
6.4%
0 2398
 
6.2%
6 2380
 
6.2%

Most occurring scripts

ValueCountFrequency (%)
Latin 155220
80.2%
Common 38370
 
19.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
M 16536
 
10.7%
Z 13193
 
8.5%
A 11705
 
7.5%
L 11297
 
7.3%
W 9959
 
6.4%
G 9016
 
5.8%
B 8130
 
5.2%
P 7863
 
5.1%
N 6016
 
3.9%
D 5933
 
3.8%
Other values (16) 55572
35.8%
Common
ValueCountFrequency (%)
2 9278
24.2%
5 6315
16.5%
1 4776
12.4%
9 3162
 
8.2%
3 2640
 
6.9%
4 2507
 
6.5%
7 2475
 
6.5%
8 2439
 
6.4%
0 2398
 
6.2%
6 2380
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 193590
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
M 16536
 
8.5%
Z 13193
 
6.8%
A 11705
 
6.0%
L 11297
 
5.8%
W 9959
 
5.1%
2 9278
 
4.8%
G 9016
 
4.7%
B 8130
 
4.2%
P 7863
 
4.1%
5 6315
 
3.3%
Other values (26) 90298
46.6%

id_pieza
Real number (ℝ)

Unique 

Distinct19359
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean58385.782
Minimum29479
Maximum93099
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size170.3 KiB
2024-12-29T11:09:54.356637image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Quantile statistics

Minimum29479
5-th percentile32675.7
Q143363.5
median57214
Q373007
95-th percentile87519
Maximum93099
Range63620
Interquartile range (IQR)29643.5

Descriptive statistics

Standard deviation17538.026
Coefficient of variation (CV)0.30038179
Kurtosis-1.1380243
Mean58385.782
Median Absolute Deviation (MAD)14589
Skewness0.17137332
Sum1.1302904 × 109
Variance3.0758235 × 108
MonotonicityNot monotonic
2024-12-29T11:09:54.523541image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
29479 1
 
< 0.1%
67592 1
 
< 0.1%
67585 1
 
< 0.1%
67584 1
 
< 0.1%
67578 1
 
< 0.1%
67575 1
 
< 0.1%
67573 1
 
< 0.1%
67572 1
 
< 0.1%
67569 1
 
< 0.1%
67568 1
 
< 0.1%
Other values (19349) 19349
99.9%
ValueCountFrequency (%)
29479 1
< 0.1%
29480 1
< 0.1%
29481 1
< 0.1%
29482 1
< 0.1%
29487 1
< 0.1%
29490 1
< 0.1%
29491 1
< 0.1%
29492 1
< 0.1%
29493 1
< 0.1%
29522 1
< 0.1%
ValueCountFrequency (%)
93099 1
< 0.1%
93097 1
< 0.1%
92996 1
< 0.1%
92993 1
< 0.1%
92992 1
< 0.1%
92962 1
< 0.1%
92948 1
< 0.1%
92918 1
< 0.1%
92803 1
< 0.1%
92802 1
< 0.1%

cod_articulo
Text

Distinct2397
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
2024-12-29T11:09:54.776449image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length16
Median length14
Mean length12.181776
Min length1

Characters and Unicode

Total characters235827
Distinct characters82
Distinct categories14 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1606 ?
Unique (%)8.3%

Sample

1st rowAZXWSCLOUDWIFI
2nd rowAZX6QADAPTHIT
3rd rowAZX6QADAPTHIT
4th rowAZX6CCP
5th rowAZCE6EXP8Z
ValueCountFrequency (%)
azce6thinkrb 1964
 
10.0%
azce6bluefacecb 1532
 
7.8%
azce6bluezerocb 755
 
3.8%
azx6wsc5ger 666
 
3.4%
azce6flexa3 573
 
2.9%
azpv8cb1iaq 497
 
2.5%
azdi6bluefacecb 385
 
2.0%
azce6thinkcb 363
 
1.8%
azx6gtcda1 358
 
1.8%
azpv6ac1ant 338
 
1.7%
Other values (2013) 12306
62.3%
2024-12-29T11:09:55.194775image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 26270
 
11.1%
C 22373
 
9.5%
Z 19186
 
8.1%
E 19083
 
8.1%
6 16791
 
7.1%
B 13842
 
5.9%
I 9780
 
4.1%
T 8505
 
3.6%
R 8175
 
3.5%
L 6371
 
2.7%
Other values (72) 85451
36.2%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 193030
81.9%
Decimal Number 32069
 
13.6%
Lowercase Letter 9899
 
4.2%
Space Separator 476
 
0.2%
Other Punctuation 138
 
0.1%
Dash Punctuation 114
 
< 0.1%
Math Symbol 44
 
< 0.1%
Open Punctuation 22
 
< 0.1%
Connector Punctuation 13
 
< 0.1%
Control 10
 
< 0.1%
Other values (4) 12
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 1278
12.9%
c 1100
11.1%
e 1031
 
10.4%
z 923
 
9.3%
b 730
 
7.4%
i 538
 
5.4%
r 475
 
4.8%
t 454
 
4.6%
n 363
 
3.7%
p 354
 
3.6%
Other values (17) 2653
26.8%
Uppercase Letter
ValueCountFrequency (%)
A 26270
13.6%
C 22373
11.6%
Z 19186
 
9.9%
E 19083
 
9.9%
B 13842
 
7.2%
I 9780
 
5.1%
T 8505
 
4.4%
R 8175
 
4.2%
L 6371
 
3.3%
N 6196
 
3.2%
Other values (16) 53249
27.6%
Decimal Number
ValueCountFrequency (%)
6 16791
52.4%
0 5198
 
16.2%
1 3646
 
11.4%
5 1627
 
5.1%
3 1591
 
5.0%
8 1545
 
4.8%
2 1114
 
3.5%
4 346
 
1.1%
7 195
 
0.6%
9 16
 
< 0.1%
Other Punctuation
ValueCountFrequency (%)
? 58
42.0%
/ 38
27.5%
. 24
17.4%
, 6
 
4.3%
* 5
 
3.6%
% 4
 
2.9%
: 3
 
2.2%
Math Symbol
ValueCountFrequency (%)
+ 43
97.7%
< 1
 
2.3%
Open Punctuation
ValueCountFrequency (%)
( 21
95.5%
[ 1
 
4.5%
Space Separator
ValueCountFrequency (%)
476
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 114
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 13
100.0%
Control
ValueCountFrequency (%)
10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Other Number
ValueCountFrequency (%)
² 2
100.0%
Other Symbol
ValueCountFrequency (%)
° 2
100.0%
Modifier Symbol
ValueCountFrequency (%)
¨ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 202929
86.0%
Common 32898
 
14.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 26270
12.9%
C 22373
 
11.0%
Z 19186
 
9.5%
E 19083
 
9.4%
B 13842
 
6.8%
I 9780
 
4.8%
T 8505
 
4.2%
R 8175
 
4.0%
L 6371
 
3.1%
N 6196
 
3.1%
Other values (43) 63148
31.1%
Common
ValueCountFrequency (%)
6 16791
51.0%
0 5198
 
15.8%
1 3646
 
11.1%
5 1627
 
4.9%
3 1591
 
4.8%
8 1545
 
4.7%
2 1114
 
3.4%
476
 
1.4%
4 346
 
1.1%
7 195
 
0.6%
Other values (19) 369
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 235820
> 99.9%
None 7
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
A 26270
 
11.1%
C 22373
 
9.5%
Z 19186
 
8.1%
E 19083
 
8.1%
6 16791
 
7.1%
B 13842
 
5.9%
I 9780
 
4.1%
T 8505
 
3.6%
R 8175
 
3.5%
L 6371
 
2.7%
Other values (68) 85444
36.2%
None
ValueCountFrequency (%)
é 2
28.6%
² 2
28.6%
° 2
28.6%
¨ 1
14.3%

desc_problema_translated
Text

Missing 

Distinct12956
Distinct (%)68.9%
Missing543
Missing (%)2.8%
Memory size2.6 MiB
2024-12-29T11:09:55.530932image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length582
Median length460
Mean length76.8201
Min length1

Characters and Unicode

Total characters1445447
Distinct characters131
Distinct categories18 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique10700 ?
Unique (%)56.9%

Sample

1st rowDespués del diagnóstico de HOTLINE
2nd rowDespués del diagnóstico de HOTLINE
3rd rowDespués del diagnóstico de HOTLINE
4th rowCAMBIO CPP EN GARANTIA POR PROBLEMAS COMUNICACION
5th rowTARJETA POTENTE PARA 8 ZONAS
ValueCountFrequency (%)
de 12301
 
5.3%
no 7541
 
3.3%
el 7127
 
3.1%
la 6878
 
3.0%
en 5104
 
2.2%
y 4292
 
1.9%
se 4263
 
1.9%
que 4023
 
1.7%
con 3990
 
1.7%
funciona 2814
 
1.2%
Other values (14919) 171678
74.6%
2024-12-29T11:09:56.089303image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
205989
 
14.3%
e 78367
 
5.4%
a 70344
 
4.9%
A 67014
 
4.6%
E 66103
 
4.6%
o 56965
 
3.9%
n 47987
 
3.3%
O 46573
 
3.2%
N 44349
 
3.1%
r 39104
 
2.7%
Other values (121) 722652
50.0%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 595509
41.2%
Uppercase Letter 549004
38.0%
Space Separator 205991
 
14.3%
Decimal Number 49618
 
3.4%
Other Punctuation 21147
 
1.5%
Control 17658
 
1.2%
Dash Punctuation 1676
 
0.1%
Open Punctuation 1266
 
0.1%
Close Punctuation 1232
 
0.1%
Other Symbol 1099
 
0.1%
Other values (8) 1247
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 78367
13.2%
a 70344
11.8%
o 56965
9.6%
n 47987
 
8.1%
r 39104
 
6.6%
i 37277
 
6.3%
t 36238
 
6.1%
l 34162
 
5.7%
s 33997
 
5.7%
c 30178
 
5.1%
Other values (28) 130890
22.0%
Uppercase Letter
ValueCountFrequency (%)
A 67014
12.2%
E 66103
12.0%
O 46573
 
8.5%
N 44349
 
8.1%
I 34347
 
6.3%
T 33670
 
6.1%
R 32673
 
6.0%
L 30667
 
5.6%
C 30250
 
5.5%
S 30089
 
5.5%
Other values (28) 133269
24.3%
Other Punctuation
ValueCountFrequency (%)
. 10420
49.3%
, 6212
29.4%
: 1975
 
9.3%
/ 1455
 
6.9%
" 255
 
1.2%
? 225
 
1.1%
% 92
 
0.4%
; 89
 
0.4%
* 85
 
0.4%
\ 84
 
0.4%
Other values (8) 255
 
1.2%
Decimal Number
ValueCountFrequency (%)
0 9874
19.9%
1 7176
14.5%
2 6763
13.6%
6 6188
12.5%
3 4680
9.4%
5 3535
 
7.1%
4 3403
 
6.9%
8 2966
 
6.0%
7 2560
 
5.2%
9 2473
 
5.0%
Math Symbol
ValueCountFrequency (%)
+ 469
74.8%
> 104
 
16.6%
= 36
 
5.7%
< 17
 
2.7%
| 1
 
0.2%
Control
ValueCountFrequency (%)
8855
50.1%
8690
49.2%
113
 
0.6%
Space Separator
ValueCountFrequency (%)
205989
> 99.9%
  2
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
- 1673
99.8%
– 3
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 1265
99.9%
[ 1
 
0.1%
Close Punctuation
ValueCountFrequency (%)
) 1231
99.9%
] 1
 
0.1%
Other Symbol
ValueCountFrequency (%)
° 1095
99.6%
™ 4
 
0.4%
Other Letter
ValueCountFrequency (%)
º 461
95.6%
ª 21
 
4.4%
Modifier Symbol
ValueCountFrequency (%)
´ 2
66.7%
` 1
33.3%
Connector Punctuation
ValueCountFrequency (%)
_ 78
100.0%
Initial Punctuation
ValueCountFrequency (%)
“ 25
100.0%
Final Punctuation
ValueCountFrequency (%)
” 25
100.0%
Format
ValueCountFrequency (%)
​ 6
100.0%
Currency Symbol
ValueCountFrequency (%)
£ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1144995
79.2%
Common 300452
 
20.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
e 78367
 
6.8%
a 70344
 
6.1%
A 67014
 
5.9%
E 66103
 
5.8%
o 56965
 
5.0%
n 47987
 
4.2%
O 46573
 
4.1%
N 44349
 
3.9%
r 39104
 
3.4%
i 37277
 
3.3%
Other values (68) 590912
51.6%
Common
ValueCountFrequency (%)
205989
68.6%
. 10420
 
3.5%
0 9874
 
3.3%
8855
 
2.9%
8690
 
2.9%
1 7176
 
2.4%
2 6763
 
2.3%
, 6212
 
2.1%
6 6188
 
2.1%
3 4680
 
1.6%
Other values (43) 25605
 
8.5%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1429298
98.9%
None 16086
 
1.1%
Punctuation 59
 
< 0.1%
Letterlike Symbols 4
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
205989
 
14.4%
e 78367
 
5.5%
a 70344
 
4.9%
A 67014
 
4.7%
E 66103
 
4.6%
o 56965
 
4.0%
n 47987
 
3.4%
O 46573
 
3.3%
N 44349
 
3.1%
r 39104
 
2.7%
Other values (83) 706503
49.4%
None
ValueCountFrequency (%)
ó 3799
23.6%
í 2550
15.9%
Ó 1964
12.2%
Í 1323
 
8.2%
á 1194
 
7.4%
é 1184
 
7.4%
° 1095
 
6.8%
ú 896
 
5.6%
º 461
 
2.9%
ñ 367
 
2.3%
Other values (23) 1253
 
7.8%
Punctuation
ValueCountFrequency (%)
“ 25
42.4%
” 25
42.4%
​ 6
 
10.2%
– 3
 
5.1%
Letterlike Symbols
ValueCountFrequency (%)
™ 4
100.0%

descripcion_translated
Text

Missing 

Distinct5634
Distinct (%)36.1%
Missing3752
Missing (%)19.4%
Memory size1.4 MiB
2024-12-29T11:09:56.381871image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length76
Median length51
Mean length27.055488
Min length1

Characters and Unicode

Total characters422255
Distinct characters104
Distinct categories12 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique3989 ?
Unique (%)25.6%

Sample

1st rowPasarela de comunicaciones HITACHI RPI
2nd rowPuerta de enlace de comunicación
3rd rowCENTRAL DE PRODUCCION
4th row0000
5th rowMANDO
ValueCountFrequency (%)
termostato 4048
 
6.5%
de 3402
 
5.5%
airzone 2990
 
4.8%
central 1776
 
2.9%
radio 1563
 
2.5%
blanco 1425
 
2.3%
cable 1389
 
2.2%
web 1280
 
2.1%
blueface 1260
 
2.0%
servidor 1243
 
2.0%
Other values (2564) 41511
67.1%
2024-12-29T11:09:56.906101image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
46338
 
11.0%
A 31677
 
7.5%
E 29936
 
7.1%
O 27825
 
6.6%
T 22251
 
5.3%
R 22182
 
5.3%
I 18379
 
4.4%
N 17075
 
4.0%
L 15748
 
3.7%
C 14488
 
3.4%
Other values (94) 176356
41.8%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 274083
64.9%
Lowercase Letter 84826
 
20.1%
Space Separator 46338
 
11.0%
Decimal Number 12341
 
2.9%
Other Punctuation 2615
 
0.6%
Dash Punctuation 1233
 
0.3%
Open Punctuation 378
 
0.1%
Close Punctuation 269
 
0.1%
Math Symbol 129
 
< 0.1%
Other Symbol 26
 
< 0.1%
Other values (2) 17
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A 31677
11.6%
E 29936
10.9%
O 27825
10.2%
T 22251
 
8.1%
R 22182
 
8.1%
I 18379
 
6.7%
N 17075
 
6.2%
L 15748
 
5.7%
C 14488
 
5.3%
S 10014
 
3.7%
Other values (24) 64508
23.5%
Lowercase Letter
ValueCountFrequency (%)
a 10202
12.0%
e 9738
11.5%
o 9717
11.5%
r 7493
8.8%
t 6405
 
7.6%
n 5622
 
6.6%
i 5447
 
6.4%
l 4593
 
5.4%
c 4443
 
5.2%
d 3764
 
4.4%
Other values (22) 17402
20.5%
Other Punctuation
ValueCountFrequency (%)
. 2020
77.2%
/ 303
 
11.6%
* 132
 
5.0%
, 88
 
3.4%
: 25
 
1.0%
\ 13
 
0.5%
? 10
 
0.4%
" 8
 
0.3%
¿ 5
 
0.2%
' 3
 
0.1%
Other values (5) 8
 
0.3%
Decimal Number
ValueCountFrequency (%)
0 3320
26.9%
6 2294
18.6%
3 1686
13.7%
2 1335
10.8%
8 1282
 
10.4%
5 993
 
8.0%
1 905
 
7.3%
4 417
 
3.4%
7 79
 
0.6%
9 30
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 375
99.2%
[ 3
 
0.8%
Close Punctuation
ValueCountFrequency (%)
) 266
98.9%
] 3
 
1.1%
Math Symbol
ValueCountFrequency (%)
+ 124
96.1%
> 5
 
3.9%
Other Symbol
ValueCountFrequency (%)
™ 20
76.9%
° 6
 
23.1%
Other Letter
ValueCountFrequency (%)
º 15
93.8%
ª 1
 
6.2%
Space Separator
ValueCountFrequency (%)
46338
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1233
100.0%
Control
ValueCountFrequency (%)
 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 358925
85.0%
Common 63330
 
15.0%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 31677
 
8.8%
E 29936
 
8.3%
O 27825
 
7.8%
T 22251
 
6.2%
R 22182
 
6.2%
I 18379
 
5.1%
N 17075
 
4.8%
L 15748
 
4.4%
C 14488
 
4.0%
a 10202
 
2.8%
Other values (58) 149162
41.6%
Common
ValueCountFrequency (%)
46338
73.2%
0 3320
 
5.2%
6 2294
 
3.6%
. 2020
 
3.2%
3 1686
 
2.7%
2 1335
 
2.1%
8 1282
 
2.0%
- 1233
 
1.9%
5 993
 
1.6%
1 905
 
1.4%
Other values (26) 1924
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 420365
99.6%
None 1870
 
0.4%
Letterlike Symbols 20
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
46338
 
11.0%
A 31677
 
7.5%
E 29936
 
7.1%
O 27825
 
6.6%
T 22251
 
5.3%
R 22182
 
5.3%
I 18379
 
4.4%
N 17075
 
4.1%
L 15748
 
3.7%
C 14488
 
3.4%
Other values (72) 174466
41.5%
None
ValueCountFrequency (%)
Ó 867
46.4%
ó 407
21.8%
É 208
 
11.1%
á 134
 
7.2%
Á 71
 
3.8%
é 69
 
3.7%
Í 26
 
1.4%
Ú 23
 
1.2%
º 15
 
0.8%
Ø 13
 
0.7%
Other values (11) 37
 
2.0%
Letterlike Symbols
ValueCountFrequency (%)
™ 20
100.0%

problema_translated
Text

Distinct13486
Distinct (%)69.7%
Missing1
Missing (%)< 0.1%
Memory size2.1 MiB
2024-12-29T11:09:57.263194image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length314
Median length257
Mean length46.959655
Min length1

Characters and Unicode

Total characters909045
Distinct characters124
Distinct categories17 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique11961 ?
Unique (%)61.8%

Sample

1st rowNo más comunicación, asociación WIFI imposible.
2nd rowproblema de comunicacion
3rd rowproblema de comunicacion
4th rowfallo en comunicacion central de produccion
5th rowRAS
ValueCountFrequency (%)
de 7187
 
4.9%
no 6144
 
4.2%
el 4753
 
3.3%
la 4201
 
2.9%
en 3239
 
2.2%
funciona 2749
 
1.9%
se 2676
 
1.8%
con 2458
 
1.7%
termostato 2263
 
1.6%
y 2083
 
1.4%
Other values (12287) 107942
74.1%
2024-12-29T11:09:57.813555image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
124248
 
13.7%
A 46569
 
5.1%
E 46206
 
5.1%
e 43957
 
4.8%
a 40074
 
4.4%
O 35680
 
3.9%
N 34147
 
3.8%
o 32876
 
3.6%
n 26951
 
3.0%
I 25499
 
2.8%
Other values (114) 452838
49.8%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 387929
42.7%
Lowercase Letter 336655
37.0%
Space Separator 124250
 
13.7%
Decimal Number 36352
 
4.0%
Other Punctuation 12065
 
1.3%
Control 7771
 
0.9%
Other Symbol 1050
 
0.1%
Dash Punctuation 920
 
0.1%
Open Punctuation 674
 
0.1%
Close Punctuation 656
 
0.1%
Other values (7) 723
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 43957
13.1%
a 40074
11.9%
o 32876
9.8%
n 26951
 
8.0%
r 22325
 
6.6%
t 21493
 
6.4%
i 21277
 
6.3%
l 19515
 
5.8%
c 17810
 
5.3%
s 17386
 
5.2%
Other values (27) 72991
21.7%
Uppercase Letter
ValueCountFrequency (%)
A 46569
12.0%
E 46206
11.9%
O 35680
 
9.2%
N 34147
 
8.8%
I 25499
 
6.6%
T 24328
 
6.3%
R 23754
 
6.1%
C 21393
 
5.5%
L 20548
 
5.3%
S 19517
 
5.0%
Other values (25) 90288
23.3%
Other Punctuation
ValueCountFrequency (%)
. 6219
51.5%
, 3475
28.8%
: 944
 
7.8%
/ 600
 
5.0%
\ 156
 
1.3%
* 156
 
1.3%
" 141
 
1.2%
? 140
 
1.2%
% 63
 
0.5%
¿ 50
 
0.4%
Other values (7) 121
 
1.0%
Decimal Number
ValueCountFrequency (%)
0 6186
17.0%
1 5340
14.7%
2 4934
13.6%
6 4028
11.1%
3 3554
9.8%
4 2785
7.7%
5 2708
7.4%
8 2404
 
6.6%
7 2235
 
6.1%
9 2178
 
6.0%
Math Symbol
ValueCountFrequency (%)
+ 193
75.4%
> 40
 
15.6%
= 17
 
6.6%
< 6
 
2.3%
Control
ValueCountFrequency (%)
3937
50.7%
3789
48.8%
45
 
0.6%
Modifier Symbol
ValueCountFrequency (%)
´ 1
33.3%
¨ 1
33.3%
` 1
33.3%
Space Separator
ValueCountFrequency (%)
124248
> 99.9%
  2
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
- 918
99.8%
– 2
 
0.2%
Open Punctuation
ValueCountFrequency (%)
( 672
99.7%
[ 2
 
0.3%
Close Punctuation
ValueCountFrequency (%)
) 654
99.7%
] 2
 
0.3%
Other Letter
ValueCountFrequency (%)
º 274
95.8%
ª 12
 
4.2%
Other Symbol
ValueCountFrequency (%)
° 1050
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 158
100.0%
Format
ValueCountFrequency (%)
​ 16
100.0%
Initial Punctuation
ValueCountFrequency (%)
“ 2
100.0%
Final Punctuation
ValueCountFrequency (%)
” 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 724870
79.7%
Common 184175
 
20.3%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 46569
 
6.4%
E 46206
 
6.4%
e 43957
 
6.1%
a 40074
 
5.5%
O 35680
 
4.9%
N 34147
 
4.7%
o 32876
 
4.5%
n 26951
 
3.7%
I 25499
 
3.5%
T 24328
 
3.4%
Other values (64) 368583
50.8%
Common
ValueCountFrequency (%)
124248
67.5%
. 6219
 
3.4%
0 6186
 
3.4%
1 5340
 
2.9%
2 4934
 
2.7%
6 4028
 
2.2%
3937
 
2.1%
3789
 
2.1%
3 3554
 
1.9%
, 3475
 
1.9%
Other values (40) 18465
 
10.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 898373
98.8%
None 10650
 
1.2%
Punctuation 22
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
124248
 
13.8%
A 46569
 
5.2%
E 46206
 
5.1%
e 43957
 
4.9%
a 40074
 
4.5%
O 35680
 
4.0%
N 34147
 
3.8%
o 32876
 
3.7%
n 26951
 
3.0%
I 25499
 
2.8%
Other values (81) 442166
49.2%
None
ValueCountFrequency (%)
ó 2224
20.9%
í 1464
13.7%
Ó 1375
12.9%
Í 1139
10.7%
° 1050
9.9%
á 750
 
7.0%
é 604
 
5.7%
ú 523
 
4.9%
º 274
 
2.6%
Ú 256
 
2.4%
Other values (19) 991
9.3%
Punctuation
ValueCountFrequency (%)
​ 16
72.7%
– 2
 
9.1%
“ 2
 
9.1%
” 2
 
9.1%

CODART_A3
Text

Distinct1141
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
2024-12-29T11:09:58.056987image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length15
Median length14
Mean length12.179348
Min length3

Characters and Unicode

Total characters235780
Distinct characters39
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique591 ?
Unique (%)3.1%

Sample

1st rowAZXWSCLOUDWIFI
2nd rowAZX6QADAPTHIT
3rd rowAZX6QADAPTHIT
4th rowAZX6CCP
5th rowAZCE6EXP8Z
ValueCountFrequency (%)
azce6thinkrb 2086
 
10.8%
azce6bluefacecb 1690
 
8.7%
azce6bluezerocb 815
 
4.2%
azx6wsc5ger 747
 
3.9%
azce6flexa3 603
 
3.1%
azpv8cb1iaq 520
 
2.7%
azce6ibpro6e 457
 
2.4%
azdi6bluefacecb 411
 
2.1%
azce6thinkcb 384
 
2.0%
azx6gtcda1 383
 
2.0%
Other values (1131) 11263
58.2%
2024-12-29T11:09:58.448264image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 27544
 
11.7%
C 23649
 
10.0%
E 20236
 
8.6%
Z 20117
 
8.5%
6 17025
 
7.2%
B 14706
 
6.2%
I 10314
 
4.4%
T 8956
 
3.8%
R 8624
 
3.7%
L 6658
 
2.8%
Other values (29) 77951
33.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 203398
86.3%
Decimal Number 32146
 
13.6%
Dash Punctuation 133
 
0.1%
Connector Punctuation 55
 
< 0.1%
Space Separator 48
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A 27544
13.5%
C 23649
11.6%
E 20236
 
9.9%
Z 20117
 
9.9%
B 14706
 
7.2%
I 10314
 
5.1%
T 8956
 
4.4%
R 8624
 
4.2%
L 6658
 
3.3%
N 6538
 
3.2%
Other values (16) 56056
27.6%
Decimal Number
ValueCountFrequency (%)
6 17025
53.0%
0 5117
 
15.9%
1 3613
 
11.2%
5 1649
 
5.1%
3 1584
 
4.9%
8 1532
 
4.8%
2 1090
 
3.4%
4 333
 
1.0%
7 190
 
0.6%
9 13
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
- 133
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 55
100.0%
Space Separator
ValueCountFrequency (%)
48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 203398
86.3%
Common 32382
 
13.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 27544
13.5%
C 23649
11.6%
E 20236
 
9.9%
Z 20117
 
9.9%
B 14706
 
7.2%
I 10314
 
5.1%
T 8956
 
4.4%
R 8624
 
4.2%
L 6658
 
3.3%
N 6538
 
3.2%
Other values (16) 56056
27.6%
Common
ValueCountFrequency (%)
6 17025
52.6%
0 5117
 
15.8%
1 3613
 
11.2%
5 1649
 
5.1%
3 1584
 
4.9%
8 1532
 
4.7%
2 1090
 
3.4%
4 333
 
1.0%
7 190
 
0.6%
- 133
 
0.4%
Other values (3) 116
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 235780
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
A 27544
 
11.7%
C 23649
 
10.0%
E 20236
 
8.6%
Z 20117
 
8.5%
6 17025
 
7.2%
B 14706
 
6.2%
I 10314
 
4.4%
T 8956
 
3.8%
R 8624
 
3.7%
L 6658
 
2.8%
Other values (29) 77951
33.1%

Fuzzy_Score
Real number (ℝ)

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean99.437574
Minimum85
Maximum100
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size151.4 KiB
2024-12-29T11:09:58.592361image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Quantile statistics

Minimum85
5-th percentile95
Q1100
median100
Q3100
95-th percentile100
Maximum100
Range15
Interquartile range (IQR)0

Descriptive statistics

Standard deviation2.0492478
Coefficient of variation (CV)0.020608385
Kurtosis16.190582
Mean99.437574
Median Absolute Deviation (MAD)0
Skewness-3.9921457
Sum1925012
Variance4.1994167
MonotonicityNot monotonic
2024-12-29T11:09:58.731980image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
100 17731
91.6%
96 349
 
1.8%
92 231
 
1.2%
97 229
 
1.2%
91 191
 
1.0%
95 184
 
1.0%
93 173
 
0.9%
90 133
 
0.7%
86 43
 
0.2%
87 38
 
0.2%
Other values (4) 57
 
0.3%
ValueCountFrequency (%)
85 10
 
0.1%
86 43
 
0.2%
87 38
 
0.2%
88 19
 
0.1%
89 27
 
0.1%
90 133
0.7%
91 191
1.0%
92 231
1.2%
93 173
0.9%
94 1
 
< 0.1%
ValueCountFrequency (%)
100 17731
91.6%
97 229
 
1.2%
96 349
 
1.8%
95 184
 
1.0%
94 1
 
< 0.1%
93 173
 
0.9%
92 231
 
1.2%
91 191
 
1.0%
90 133
 
0.7%
89 27
 
0.1%

CODART
Text

Distinct1141
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size1.3 MiB
2024-12-29T11:10:00.016091image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length15
Median length14
Mean length12.179348
Min length3

Characters and Unicode

Total characters235780
Distinct characters39
Distinct categories5 ?
Distinct scripts2 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique591 ?
Unique (%)3.1%

Sample

1st rowAZXWSCLOUDWIFI
2nd rowAZX6QADAPTHIT
3rd rowAZX6QADAPTHIT
4th rowAZX6CCP
5th rowAZCE6EXP8Z
ValueCountFrequency (%)
azce6thinkrb 2086
 
10.8%
azce6bluefacecb 1690
 
8.7%
azce6bluezerocb 815
 
4.2%
azx6wsc5ger 747
 
3.9%
azce6flexa3 603
 
3.1%
azpv8cb1iaq 520
 
2.7%
azce6ibpro6e 457
 
2.4%
azdi6bluefacecb 411
 
2.1%
azce6thinkcb 384
 
2.0%
azx6gtcda1 383
 
2.0%
Other values (1131) 11263
58.2%
2024-12-29T11:10:00.388139image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
A 27544
 
11.7%
C 23649
 
10.0%
E 20236
 
8.6%
Z 20117
 
8.5%
6 17025
 
7.2%
B 14706
 
6.2%
I 10314
 
4.4%
T 8956
 
3.8%
R 8624
 
3.7%
L 6658
 
2.8%
Other values (29) 77951
33.1%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 203398
86.3%
Decimal Number 32146
 
13.6%
Dash Punctuation 133
 
0.1%
Connector Punctuation 55
 
< 0.1%
Space Separator 48
 
< 0.1%

Most frequent character per category

Uppercase Letter
ValueCountFrequency (%)
A 27544
13.5%
C 23649
11.6%
E 20236
 
9.9%
Z 20117
 
9.9%
B 14706
 
7.2%
I 10314
 
5.1%
T 8956
 
4.4%
R 8624
 
4.2%
L 6658
 
3.3%
N 6538
 
3.2%
Other values (16) 56056
27.6%
Decimal Number
ValueCountFrequency (%)
6 17025
53.0%
0 5117
 
15.9%
1 3613
 
11.2%
5 1649
 
5.1%
3 1584
 
4.9%
8 1532
 
4.8%
2 1090
 
3.4%
4 333
 
1.0%
7 190
 
0.6%
9 13
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
- 133
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 55
100.0%
Space Separator
ValueCountFrequency (%)
48
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 203398
86.3%
Common 32382
 
13.7%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 27544
13.5%
C 23649
11.6%
E 20236
 
9.9%
Z 20117
 
9.9%
B 14706
 
7.2%
I 10314
 
5.1%
T 8956
 
4.4%
R 8624
 
4.2%
L 6658
 
3.3%
N 6538
 
3.2%
Other values (16) 56056
27.6%
Common
ValueCountFrequency (%)
6 17025
52.6%
0 5117
 
15.8%
1 3613
 
11.2%
5 1649
 
5.1%
3 1584
 
4.9%
8 1532
 
4.7%
2 1090
 
3.4%
4 333
 
1.0%
7 190
 
0.6%
- 133
 
0.4%
Other values (3) 116
 
0.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 235780
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
A 27544
 
11.7%
C 23649
 
10.0%
E 20236
 
8.6%
Z 20117
 
8.5%
6 17025
 
7.2%
B 14706
 
6.2%
I 10314
 
4.4%
T 8956
 
3.8%
R 8624
 
3.7%
L 6658
 
2.8%
Other values (29) 77951
33.1%

DESCART
Text

Distinct1134
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size2.1 MiB
2024-12-29T11:10:00.617091image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length98
Median length88
Mean length49.520068
Min length5

Characters and Unicode

Total characters958659
Distinct characters81
Distinct categories12 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique587 ?
Unique (%)3.0%

Sample

1st rowWebserver Airzone Cloud Wi-Fi (2013)
2nd rowPasarela comunicaciones Airzone-Hitachi RPI
3rd rowPasarela comunicaciones Airzone-Hitachi RPI
4th rowCentral de control de producción Airzone
5th rowMódulo de expansión Airzone 2 zonas (7 y 8)
ValueCountFrequency (%)
airzone 15405
 
10.9%
blanco 7140
 
5.1%
termostato 7085
 
5.0%
de 6635
 
4.7%
ce6 6030
 
4.3%
8z 5752
 
4.1%
cable 5347
 
3.8%
central 3778
 
2.7%
blueface 3650
 
2.6%
think 2945
 
2.1%
Other values (709) 77311
54.8%
2024-12-29T11:10:01.024455image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
121720
 
12.7%
o 85371
 
8.9%
e 76600
 
8.0%
a 60078
 
6.3%
r 58041
 
6.1%
n 50662
 
5.3%
i 45513
 
4.7%
l 40169
 
4.2%
c 35230
 
3.7%
t 32947
 
3.4%
Other values (71) 352328
36.8%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 640859
66.8%
Uppercase Letter 124653
 
13.0%
Space Separator 121720
 
12.7%
Decimal Number 43003
 
4.5%
Open Punctuation 8453
 
0.9%
Close Punctuation 8453
 
0.9%
Other Punctuation 5865
 
0.6%
Dash Punctuation 5038
 
0.5%
Math Symbol 530
 
0.1%
Other Letter 64
 
< 0.1%
Other values (2) 21
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
o 85371
13.3%
e 76600
12.0%
a 60078
9.4%
r 58041
9.1%
n 50662
 
7.9%
i 45513
 
7.1%
l 40169
 
6.3%
c 35230
 
5.5%
t 32947
 
5.1%
m 24768
 
3.9%
Other values (21) 131480
20.5%
Uppercase Letter
ValueCountFrequency (%)
A 23291
18.7%
C 13649
10.9%
E 13042
10.5%
T 12556
10.1%
Z 12418
10.0%
R 5132
 
4.1%
I 4865
 
3.9%
B 4795
 
3.8%
M 4618
 
3.7%
P 4231
 
3.4%
Other values (16) 26056
20.9%
Decimal Number
ValueCountFrequency (%)
6 10029
23.3%
0 8710
20.3%
8 7538
17.5%
3 5156
12.0%
2 5082
11.8%
5 2537
 
5.9%
4 1873
 
4.4%
1 1797
 
4.2%
7 254
 
0.6%
9 27
 
0.1%
Other Punctuation
ValueCountFrequency (%)
. 4382
74.7%
/ 1181
 
20.1%
* 182
 
3.1%
, 100
 
1.7%
" 19
 
0.3%
% 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
121720
100.0%
Open Punctuation
ValueCountFrequency (%)
( 8453
100.0%
Close Punctuation
ValueCountFrequency (%)
) 8453
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5038
100.0%
Math Symbol
ValueCountFrequency (%)
+ 530
100.0%
Other Letter
ValueCountFrequency (%)
º 64
100.0%
Other Symbol
ValueCountFrequency (%)
° 16
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 765576
79.9%
Common 193083
 
20.1%

Most frequent character per script

Latin
ValueCountFrequency (%)
o 85371
 
11.2%
e 76600
 
10.0%
a 60078
 
7.8%
r 58041
 
7.6%
n 50662
 
6.6%
i 45513
 
5.9%
l 40169
 
5.2%
c 35230
 
4.6%
t 32947
 
4.3%
m 24768
 
3.2%
Other values (48) 256197
33.5%
Common
ValueCountFrequency (%)
121720
63.0%
6 10029
 
5.2%
0 8710
 
4.5%
( 8453
 
4.4%
) 8453
 
4.4%
8 7538
 
3.9%
3 5156
 
2.7%
2 5082
 
2.6%
- 5038
 
2.6%
. 4382
 
2.3%
Other values (13) 8522
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 956694
99.8%
None 1965
 
0.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
121720
 
12.7%
o 85371
 
8.9%
e 76600
 
8.0%
a 60078
 
6.3%
r 58041
 
6.1%
n 50662
 
5.3%
i 45513
 
4.8%
l 40169
 
4.2%
c 35230
 
3.7%
t 32947
 
3.4%
Other values (64) 350363
36.6%
None
ValueCountFrequency (%)
ó 1296
66.0%
é 412
 
21.0%
á 120
 
6.1%
º 64
 
3.3%
í 51
 
2.6%
° 16
 
0.8%
ú 6
 
0.3%

CAR1
Text

Distinct6
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size1.1 MiB
2024-12-29T11:10:01.121882image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length1
Median length1
Mean length1
Min length1

Characters and Unicode

Total characters19359
Distinct characters6
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1
ValueCountFrequency (%)
1 18733
96.8%
6 251
 
1.3%
2 233
 
1.2%
5 96
 
0.5%
3 43
 
0.2%
4 3
 
< 0.1%
2024-12-29T11:10:01.322840image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 18733
96.8%
6 251
 
1.3%
2 233
 
1.2%
5 96
 
0.5%
3 43
 
0.2%
4 3
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 19359
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 18733
96.8%
6 251
 
1.3%
2 233
 
1.2%
5 96
 
0.5%
3 43
 
0.2%
4 3
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Common 19359
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 18733
96.8%
6 251
 
1.3%
2 233
 
1.2%
5 96
 
0.5%
3 43
 
0.2%
4 3
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 19359
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 18733
96.8%
6 251
 
1.3%
2 233
 
1.2%
5 96
 
0.5%
3 43
 
0.2%
4 3
 
< 0.1%

CAR2
Text

Distinct26
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size1.1 MiB
2024-12-29T11:10:01.449169image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length3
Median length3
Mean length2.9637895
Min length1

Characters and Unicode

Total characters57376
Distinct characters10
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row260
2nd row260
3rd row260
4th row260
5th row250
ValueCountFrequency (%)
250 7956
41.1%
260 4055
20.9%
251 2104
 
10.9%
264 1183
 
6.1%
269 1115
 
5.8%
253 777
 
4.0%
17 558
 
2.9%
252 356
 
1.8%
270 344
 
1.8%
255 292
 
1.5%
Other values (16) 619
 
3.2%
2024-12-29T11:10:01.749602image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 19304
33.6%
0 12378
21.6%
5 11875
20.7%
6 6659
 
11.6%
1 2748
 
4.8%
4 1430
 
2.5%
9 1131
 
2.0%
7 932
 
1.6%
3 916
 
1.6%
8 3
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 57376
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 19304
33.6%
0 12378
21.6%
5 11875
20.7%
6 6659
 
11.6%
1 2748
 
4.8%
4 1430
 
2.5%
9 1131
 
2.0%
7 932
 
1.6%
3 916
 
1.6%
8 3
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Common 57376
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 19304
33.6%
0 12378
21.6%
5 11875
20.7%
6 6659
 
11.6%
1 2748
 
4.8%
4 1430
 
2.5%
9 1131
 
2.0%
7 932
 
1.6%
3 916
 
1.6%
8 3
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 57376
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 19304
33.6%
0 12378
21.6%
5 11875
20.7%
6 6659
 
11.6%
1 2748
 
4.8%
4 1430
 
2.5%
9 1131
 
2.0%
7 932
 
1.6%
3 916
 
1.6%
8 3
 
< 0.1%

CAR3
Text

Distinct31
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size1.1 MiB
2024-12-29T11:10:01.887112image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length3
Median length2
Mean length2.000155
Min length2

Characters and Unicode

Total characters38721
Distinct characters10
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

1st row93
2nd row49
3rd row49
4th row92
5th row90
ValueCountFrequency (%)
91 7068
36.5%
80 2975
15.4%
90 2332
 
12.0%
93 1875
 
9.7%
49 1679
 
8.7%
95 823
 
4.3%
31 554
 
2.9%
92 384
 
2.0%
98 364
 
1.9%
19 288
 
1.5%
Other values (21) 1017
 
5.3%
2024-12-29T11:10:02.154355image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9 15169
39.2%
1 7943
20.5%
0 5313
 
13.7%
8 3893
 
10.1%
3 2527
 
6.5%
4 2166
 
5.6%
5 877
 
2.3%
2 619
 
1.6%
7 203
 
0.5%
6 11
 
< 0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 38721
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
9 15169
39.2%
1 7943
20.5%
0 5313
 
13.7%
8 3893
 
10.1%
3 2527
 
6.5%
4 2166
 
5.6%
5 877
 
2.3%
2 619
 
1.6%
7 203
 
0.5%
6 11
 
< 0.1%

Most occurring scripts

ValueCountFrequency (%)
Common 38721
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
9 15169
39.2%
1 7943
20.5%
0 5313
 
13.7%
8 3893
 
10.1%
3 2527
 
6.5%
4 2166
 
5.6%
5 877
 
2.3%
2 619
 
1.6%
7 203
 
0.5%
6 11
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 38721
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9 15169
39.2%
1 7943
20.5%
0 5313
 
13.7%
8 3893
 
10.1%
3 2527
 
6.5%
4 2166
 
5.6%
5 877
 
2.3%
2 619
 
1.6%
7 203
 
0.5%
6 11
 
< 0.1%

CAR4
Text

Missing 

Distinct48
Distinct (%)0.5%
Missing9174
Missing (%)47.4%
Memory size868.8 KiB
2024-12-29T11:10:02.300649image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length3
Median length1
Mean length1.5116348
Min length1

Characters and Unicode

Total characters15396
Distinct characters10
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique4 ?
Unique (%)< 0.1%

Sample

1st row1
2nd row1
3rd row1
4th row1
5th row1
ValueCountFrequency (%)
1 3560
35.0%
2 2845
27.9%
204 754
 
7.4%
108 695
 
6.8%
3 495
 
4.9%
92 333
 
3.3%
32 220
 
2.2%
140 190
 
1.9%
97 178
 
1.7%
109 137
 
1.3%
Other values (38) 778
 
7.6%
2024-12-29T11:10:02.609758image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1 4918
31.9%
2 4170
27.1%
0 2001
13.0%
4 1027
 
6.7%
3 914
 
5.9%
8 877
 
5.7%
9 876
 
5.7%
7 376
 
2.4%
6 218
 
1.4%
5 19
 
0.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 15396
100.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
1 4918
31.9%
2 4170
27.1%
0 2001
13.0%
4 1027
 
6.7%
3 914
 
5.9%
8 877
 
5.7%
9 876
 
5.7%
7 376
 
2.4%
6 218
 
1.4%
5 19
 
0.1%

Most occurring scripts

ValueCountFrequency (%)
Common 15396
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
1 4918
31.9%
2 4170
27.1%
0 2001
13.0%
4 1027
 
6.7%
3 914
 
5.9%
8 877
 
5.7%
9 876
 
5.7%
7 376
 
2.4%
6 218
 
1.4%
5 19
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 15396
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1 4918
31.9%
2 4170
27.1%
0 2001
13.0%
4 1027
 
6.7%
3 914
 
5.9%
8 877
 
5.7%
9 876
 
5.7%
7 376
 
2.4%
6 218
 
1.4%
5 19
 
0.1%

text_to_analyse
Text

Distinct17118
Distinct (%)88.4%
Missing0
Missing (%)0.0%
Memory size5.8 MiB
2024-12-29T11:10:02.901810image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length909
Median length675
Mean length145.43442
Min length26

Characters and Unicode

Total characters2815465
Distinct characters136
Distinct categories18 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique16005 ?
Unique (%)82.7%

Sample

1st rowDespués del diagnóstico de HOTLINE No más comunicación, asociación WIFI imposible.
2nd rowDespués del diagnóstico de HOTLINE Pasarela de comunicaciones HITACHI RPI problema de comunicacion
3rd rowDespués del diagnóstico de HOTLINE Puerta de enlace de comunicación problema de comunicacion
4th rowCAMBIO CPP EN GARANTIA POR PROBLEMAS COMUNICACION CENTRAL DE PRODUCCION fallo en comunicacion central de produccion
5th rowTARJETA POTENTE PARA 8 ZONAS 0000 RAS
ValueCountFrequency (%)
de 22890
 
5.2%
no 13707
 
3.1%
el 11995
 
2.7%
la 11279
 
2.6%
termostato 8898
 
2.0%
en 8848
 
2.0%
se 6942
 
1.6%
con 6750
 
1.5%
y 6531
 
1.5%
que 6115
 
1.4%
Other values (19188) 333638
76.2%
2024-12-29T11:10:03.374448image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
415293
 
14.8%
A 145260
 
5.2%
E 142245
 
5.1%
e 132062
 
4.7%
a 120620
 
4.3%
O 110078
 
3.9%
o 99558
 
3.5%
N 95571
 
3.4%
n 80560
 
2.9%
T 80249
 
2.9%
Other values (126) 1393969
49.5%

Most occurring categories

ValueCountFrequency (%)
Uppercase Letter 1211016
43.0%
Lowercase Letter 1016990
36.1%
Space Separator 415297
 
14.8%
Decimal Number 98311
 
3.5%
Other Punctuation 35827
 
1.3%
Control 25430
 
0.9%
Dash Punctuation 3829
 
0.1%
Open Punctuation 2318
 
0.1%
Other Symbol 2175
 
0.1%
Close Punctuation 2157
 
0.1%
Other values (8) 2115
 
0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
e 132062
13.0%
a 120620
11.9%
o 99558
9.8%
n 80560
 
7.9%
r 68922
 
6.8%
t 64136
 
6.3%
i 64001
 
6.3%
l 58270
 
5.7%
s 54820
 
5.4%
c 52431
 
5.2%
Other values (30) 221610
21.8%
Uppercase Letter
ValueCountFrequency (%)
A 145260
12.0%
E 142245
11.7%
O 110078
 
9.1%
N 95571
 
7.9%
T 80249
 
6.6%
R 78609
 
6.5%
I 78225
 
6.5%
L 66963
 
5.5%
C 66131
 
5.5%
S 59620
 
4.9%
Other values (29) 288065
23.8%
Other Punctuation
ValueCountFrequency (%)
. 18659
52.1%
, 9775
27.3%
: 2944
 
8.2%
/ 2358
 
6.6%
" 404
 
1.1%
? 375
 
1.0%
* 373
 
1.0%
\ 253
 
0.7%
% 158
 
0.4%
¿ 138
 
0.4%
Other values (8) 390
 
1.1%
Decimal Number
ValueCountFrequency (%)
0 19380
19.7%
1 13421
13.7%
2 13032
13.3%
6 12510
12.7%
3 9920
10.1%
5 7236
 
7.4%
8 6652
 
6.8%
4 6605
 
6.7%
7 4874
 
5.0%
9 4681
 
4.8%
Math Symbol
ValueCountFrequency (%)
+ 786
77.7%
> 149
 
14.7%
= 53
 
5.2%
< 23
 
2.3%
| 1
 
0.1%
Control
ValueCountFrequency (%)
12792
50.3%
12479
49.1%
158
 
0.6%
 1
 
< 0.1%
Modifier Symbol
ValueCountFrequency (%)
´ 3
50.0%
` 2
33.3%
¨ 1
 
16.7%
Space Separator
ValueCountFrequency (%)
415293
> 99.9%
  4
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
- 3824
99.9%
– 5
 
0.1%
Open Punctuation
ValueCountFrequency (%)
( 2312
99.7%
[ 6
 
0.3%
Close Punctuation
ValueCountFrequency (%)
) 2151
99.7%
] 6
 
0.3%
Other Symbol
ValueCountFrequency (%)
° 2151
98.9%
™ 24
 
1.1%
Other Letter
ValueCountFrequency (%)
º 750
95.7%
ª 34
 
4.3%
Connector Punctuation
ValueCountFrequency (%)
_ 236
100.0%
Initial Punctuation
ValueCountFrequency (%)
“ 27
100.0%
Final Punctuation
ValueCountFrequency (%)
” 27
100.0%
Format
ValueCountFrequency (%)
​ 22
100.0%
Currency Symbol
ValueCountFrequency (%)
£ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 2228790
79.2%
Common 586675
 
20.8%

Most frequent character per script

Latin
ValueCountFrequency (%)
A 145260
 
6.5%
E 142245
 
6.4%
e 132062
 
5.9%
a 120620
 
5.4%
O 110078
 
4.9%
o 99558
 
4.5%
N 95571
 
4.3%
n 80560
 
3.6%
T 80249
 
3.6%
R 78609
 
3.5%
Other values (71) 1143978
51.3%
Common
ValueCountFrequency (%)
415293
70.8%
0 19380
 
3.3%
. 18659
 
3.2%
1 13421
 
2.3%
2 13032
 
2.2%
12792
 
2.2%
6 12510
 
2.1%
12479
 
2.1%
3 9920
 
1.7%
, 9775
 
1.7%
Other values (45) 49414
 
8.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2786754
99.0%
None 28606
 
1.0%
Punctuation 81
 
< 0.1%
Letterlike Symbols 24
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
415293
 
14.9%
A 145260
 
5.2%
E 142245
 
5.1%
e 132062
 
4.7%
a 120620
 
4.3%
O 110078
 
4.0%
o 99558
 
3.6%
N 95571
 
3.4%
n 80560
 
2.9%
T 80249
 
2.9%
Other values (83) 1365258
49.0%
None
ValueCountFrequency (%)
ó 6430
22.5%
Ó 4206
14.7%
í 4022
14.1%
Í 2488
 
8.7%
° 2151
 
7.5%
á 2078
 
7.3%
é 1857
 
6.5%
ú 1424
 
5.0%
º 750
 
2.6%
É 730
 
2.6%
Other values (28) 2470
 
8.6%
Punctuation
ValueCountFrequency (%)
“ 27
33.3%
” 27
33.3%
​ 22
27.2%
– 5
 
6.2%
Letterlike Symbols
ValueCountFrequency (%)
™ 24
100.0%

processed_text_to_analyse
Text

Distinct16800
Distinct (%)86.8%
Missing0
Missing (%)0.0%
Memory size3.3 MiB
2024-12-29T11:10:03.676645image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Length

Max length618
Median length474
Mean length110.86373
Min length9

Characters and Unicode

Total characters2146211
Distinct characters73
Distinct categories15 ?
Distinct scripts2 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique15550 ?
Unique (%)80.3%

Sample

1st rowdiagnostico hotline comunicacion asociacion wifi imposible
2nd rowdiagnostico hotline pasarela comunicaciones hitachi rpi problema comunicacion
3rd rowdiagnostico hotline puerta enlace comunicacion problema comunicacion
4th rowcambio cpp garantia problemas comunicacion central produccion fallo comunicacion central produccion
5th rowtarjeta potente 8 zonas 0000 ras
ValueCountFrequency (%)
termostato 8909
 
3.2%
funciona 5575
 
2.0%
airzone 4585
 
1.7%
central 3566
 
1.3%
garantia 3306
 
1.2%
motor 2991
 
1.1%
radio 2944
 
1.1%
blueface 2916
 
1.1%
n 2651
 
1.0%
cliente 2202
 
0.8%
Other values (17817) 235263
85.6%
2024-12-29T11:10:04.163957image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
255549
11.9%
a 222377
 
10.4%
e 189516
 
8.8%
o 173477
 
8.1%
i 140020
 
6.5%
t 134114
 
6.2%
r 131509
 
6.1%
n 128549
 
6.0%
c 108204
 
5.0%
l 86331
 
4.0%
Other values (63) 576565
26.9%

Most occurring categories

ValueCountFrequency (%)
Lowercase Letter 1781969
83.0%
Space Separator 255549
 
11.9%
Decimal Number 98311
 
4.6%
Other Punctuation 4119
 
0.2%
Other Symbol 2175
 
0.1%
Dash Punctuation 2010
 
0.1%
Math Symbol 1012
 
< 0.1%
Other Letter 784
 
< 0.1%
Connector Punctuation 164
 
< 0.1%
Close Punctuation 45
 
< 0.1%
Other values (5) 73
 
< 0.1%

Most frequent character per category

Lowercase Letter
ValueCountFrequency (%)
a 222377
12.5%
e 189516
10.6%
o 173477
9.7%
i 140020
 
7.9%
t 134114
 
7.5%
r 131509
 
7.4%
n 128549
 
7.2%
c 108204
 
6.1%
l 86331
 
4.8%
s 83085
 
4.7%
Other values (17) 384787
21.6%
Other Punctuation
ValueCountFrequency (%)
. 2454
59.6%
/ 844
 
20.5%
\ 237
 
5.8%
: 166
 
4.0%
% 157
 
3.8%
" 104
 
2.5%
, 81
 
2.0%
@ 45
 
1.1%
' 16
 
0.4%
* 5
 
0.1%
Other values (5) 10
 
0.2%
Decimal Number
ValueCountFrequency (%)
0 19380
19.7%
1 13421
13.7%
2 13032
13.3%
6 12510
12.7%
3 9920
10.1%
5 7236
 
7.4%
8 6652
 
6.8%
4 6605
 
6.7%
7 4874
 
5.0%
9 4681
 
4.8%
Math Symbol
ValueCountFrequency (%)
+ 786
77.7%
> 149
 
14.7%
= 53
 
5.2%
< 23
 
2.3%
| 1
 
0.1%
Modifier Symbol
ValueCountFrequency (%)
´ 3
50.0%
` 2
33.3%
¨ 1
 
16.7%
Other Symbol
ValueCountFrequency (%)
° 2151
98.9%
™ 24
 
1.1%
Other Letter
ValueCountFrequency (%)
º 750
95.7%
ª 34
 
4.3%
Open Punctuation
ValueCountFrequency (%)
( 41
95.3%
[ 2
 
4.7%
Space Separator
ValueCountFrequency (%)
255549
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2010
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 164
100.0%
Close Punctuation
ValueCountFrequency (%)
) 45
100.0%
Format
ValueCountFrequency (%)
​ 22
100.0%
Currency Symbol
ValueCountFrequency (%)
£ 1
100.0%
Control
ValueCountFrequency (%)
 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Latin 1782753
83.1%
Common 363458
 
16.9%

Most frequent character per script

Common
ValueCountFrequency (%)
255549
70.3%
0 19380
 
5.3%
1 13421
 
3.7%
2 13032
 
3.6%
6 12510
 
3.4%
3 9920
 
2.7%
5 7236
 
2.0%
8 6652
 
1.8%
4 6605
 
1.8%
7 4874
 
1.3%
Other values (34) 14279
 
3.9%
Latin
ValueCountFrequency (%)
a 222377
12.5%
e 189516
10.6%
o 173477
9.7%
i 140020
 
7.9%
t 134114
 
7.5%
r 131509
 
7.4%
n 128549
 
7.2%
c 108204
 
6.1%
l 86331
 
4.8%
s 83085
 
4.7%
Other values (19) 385571
21.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 2143206
99.9%
None 2959
 
0.1%
Letterlike Symbols 24
 
< 0.1%
Punctuation 22
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
255549
11.9%
a 222377
 
10.4%
e 189516
 
8.8%
o 173477
 
8.1%
i 140020
 
6.5%
t 134114
 
6.3%
r 131509
 
6.1%
n 128549
 
6.0%
c 108204
 
5.0%
l 86331
 
4.0%
Other values (51) 573560
26.8%
None
ValueCountFrequency (%)
° 2151
72.7%
º 750
 
25.3%
ª 34
 
1.1%
ø 16
 
0.5%
´ 3
 
0.1%
¨ 1
 
< 0.1%
£ 1
 
< 0.1%
 1
 
< 0.1%
· 1
 
< 0.1%
¡ 1
 
< 0.1%
Letterlike Symbols
ValueCountFrequency (%)
™ 24
100.0%
Punctuation
ValueCountFrequency (%)
​ 22
100.0%

Interactions

2024-12-29T11:09:52.571091image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
2024-12-29T11:09:52.315075image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
2024-12-29T11:09:52.696887image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
2024-12-29T11:09:52.442427image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/

Correlations

2024-12-29T11:10:04.264557image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
Fuzzy_Scoreid_pieza
Fuzzy_Score1.0000.057
id_pieza0.0571.000

Missing values

2024-12-29T11:09:52.885907image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
A simple visualization of nullity by column.
2024-12-29T11:09:53.205468image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
2024-12-29T11:09:53.434831image/svg+xmlMatplotlib v3.9.3, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

codigoid_piezacod_articulodesc_problema_translateddescripcion_translatedproblema_translatedCODART_A3Fuzzy_ScoreCODARTDESCARTCAR1CAR2CAR3CAR4text_to_analyseprocessed_text_to_analyse
0MMZPL2LO5029479AZXWSCLOUDWIFIDespués del diagnóstico de HOTLINENoneNo más comunicación, asociación WIFI imposible.AZXWSCLOUDWIFI100.0AZXWSCLOUDWIFIWebserver Airzone Cloud Wi-Fi (2013)126093NoneDespués del diagnóstico de HOTLINE No más comunicación, asociación WIFI imposible.diagnostico hotline comunicacion asociacion wifi imposible
1MMZPL2LO5029480AZX6QADAPTHITDespués del diagnóstico de HOTLINEPasarela de comunicaciones HITACHI RPIproblema de comunicacionAZX6QADAPTHIT100.0AZX6QADAPTHITPasarela comunicaciones Airzone-Hitachi RPI126049NoneDespués del diagnóstico de HOTLINE Pasarela de comunicaciones HITACHI RPI problema de comunicaciondiagnostico hotline pasarela comunicaciones hitachi rpi problema comunicacion
2MMZPL2LO5029481AZX6QADAPTHITDespués del diagnóstico de HOTLINEPuerta de enlace de comunicaciónproblema de comunicacionAZX6QADAPTHIT100.0AZX6QADAPTHITPasarela comunicaciones Airzone-Hitachi RPI126049NoneDespués del diagnóstico de HOTLINE Puerta de enlace de comunicación problema de comunicaciondiagnostico hotline puerta enlace comunicacion problema comunicacion
3L2VQL2LVF329482AZX6CCPCAMBIO CPP EN GARANTIA POR PROBLEMAS COMUNICACIONCENTRAL DE PRODUCCIONfallo en comunicacion central de produccionAZX6CCP100.0AZX6CCPCentral de control de producción Airzone126092NoneCAMBIO CPP EN GARANTIA POR PROBLEMAS COMUNICACION CENTRAL DE PRODUCCION fallo en comunicacion central de produccioncambio cpp garantia problemas comunicacion central produccion fallo comunicacion central produccion
4LGRPLMLUAE29487AZCE6EXP8ZTARJETA POTENTE PARA 8 ZONAS0000RASAZCE6EXP8Z100.0AZCE6EXP8ZMódulo de expansión Airzone 2 zonas (7 y 8)125090NoneTARJETA POTENTE PARA 8 ZONAS 0000 RAStarjeta potente 8 zonas 0000 ras
5MMDTLWPUAF29490AZCE6BLUEFACECBSE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONEMANDOMANDO QUE NO FUNCIONAAZCE6BLUEFACECB100.0AZCE6BLUEFACECBTermostato cable a color Airzone Blueface blanco 8Z (CE6)1250911SE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONE MANDO MANDO QUE NO FUNCIONAsuministraron termostatos solicitamos cambiar garantia funcionan consulta dpto tecnico airzone mando mando funciona
6MMDTLWPUAF29491AZCE6BLUEFACECBSE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONEMANDOMANDO QUE NO FUNCIONAAZCE6BLUEFACECB100.0AZCE6BLUEFACECBTermostato cable a color Airzone Blueface blanco 8Z (CE6)1250911SE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONE MANDO MANDO QUE NO FUNCIONAsuministraron termostatos solicitamos cambiar garantia funcionan consulta dpto tecnico airzone mando mando funciona
7MMDTLWPUAF29492AZCE6BLUEFACECBSE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONEMANDOMANDO QUE NO FUNCIONAAZCE6BLUEFACECB100.0AZCE6BLUEFACECBTermostato cable a color Airzone Blueface blanco 8Z (CE6)1250911SE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONE MANDO MANDO QUE NO FUNCIONAsuministraron termostatos solicitamos cambiar garantia funcionan consulta dpto tecnico airzone mando mando funciona
8MMDTLWPUAF29493AZCE6BLUEFACECBSE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONEMANDOMANDO QUE NO FUNCIONAAZCE6BLUEFACECB100.0AZCE6BLUEFACECBTermostato cable a color Airzone Blueface blanco 8Z (CE6)1250911SE SUMINISTRARON TERMOSTATOS QUE AHORA SOLICITAMOS CAMBIAR EN GARANTÍA, DADO QUE NO FUNCIONAN TRAS REALIZAR LA CONSULTA CON EL DPTO TÉCNICO DE AIRZONE MANDO MANDO QUE NO FUNCIONAsuministraron termostatos solicitamos cambiar garantia funcionan consulta dpto tecnico airzone mando mando funciona
9M2NXM2LRDA29522AZCE6BLUEFACECBBlueface No funcional visto con Sylvain Giraud por teléfonoBlueface PRO 6 BlancBlueFace no funciona después del cambio por una nueva instalación.AZCE6BLUEFACECB100.0AZCE6BLUEFACECBTermostato cable a color Airzone Blueface blanco 8Z (CE6)1250911Blueface No funcional visto con Sylvain Giraud por teléfono Blueface PRO 6 Blanc BlueFace no funciona después del cambio por una nueva instalación.blueface funcional visto sylvain giraud telefono blueface pro 6 blanc blueface funciona cambio instalacion
codigoid_piezacod_articulodesc_problema_translateddescripcion_translatedproblema_translatedCODART_A3Fuzzy_ScoreCODARTDESCARTCAR1CAR2CAR3CAR4text_to_analyseprocessed_text_to_analyse
19349MMPVAMVPAD92802AZCE8CB1DINen la puesta en marcha 1 central y un modulo no funciona, el técnico de airzone, nos comunico que se pidiera en garantía estos dos aparatos, dicho técnico le dio al cliente una numeración que es el 240404312.\r\n\r\nNecesitamos con urgencia el recambio del material, por que el cliente tiene que cerrar la obra.CENTRAL AIRZONE PARA FLEXA 4.0 EN CARRIL DINen la puesta en marcha 1 central y un modulo no funcionaAZCE8CB1DIN100.0AZCE8CB1DINCentral Airzone para Flexa 4.0 en carril DIN para control radiante frío/calor (8z)127090108en la puesta en marcha 1 central y un modulo no funciona, el técnico de airzone, nos comunico que se pidiera en garantía estos dos aparatos, dicho técnico le dio al cliente una numeración que es el 240404312.\r\n\r\nNecesitamos con urgencia el recambio del material, por que el cliente tiene que cerrar la obra. CENTRAL AIRZONE PARA FLEXA 4.0 EN CARRIL DIN en la puesta en marcha 1 central y un modulo no funcionapuesta marcha 1 central modulo funciona tecnico airzone comunico pidiera garantia aparatos tecnico cliente numeracion 240404312 necesitamos urgencia recambio material cliente cerrar obra central airzone flexa 4.0 carril din puesta marcha 1 central modulo funciona
19350MMPVAMVPAD92803AZCE8CM1VALCen la puesta en marcha 1 central y un modulo no funciona, el técnico de airzone, nos comunico que se pidiera en garantía estos dos aparatos, dicho técnico le dio al cliente una numeración que es el 240404312.\r\n\r\nNecesitamos con urgencia el recambio del material, por que el cliente tiene que cerrar la obra.MÓDULO DE CONTROL AIRZONE FLEXA 4.0 DE VÁLNO FUNCIONA LA PUESTA EN MARCHAAZCE8CM1VALC100.0AZCE8CM1VALCMódulo de control Airzone Flexa 4.0 cabezales termostáticos cableados 110/230V VALC127094Noneen la puesta en marcha 1 central y un modulo no funciona, el técnico de airzone, nos comunico que se pidiera en garantía estos dos aparatos, dicho técnico le dio al cliente una numeración que es el 240404312.\r\n\r\nNecesitamos con urgencia el recambio del material, por que el cliente tiene que cerrar la obra. MÓDULO DE CONTROL AIRZONE FLEXA 4.0 DE VÁL NO FUNCIONA LA PUESTA EN MARCHApuesta marcha 1 central modulo funciona tecnico airzone comunico pidiera garantia aparatos tecnico cliente numeracion 240404312 necesitamos urgencia recambio material cliente cerrar obra modulo control airzone flexa 4.0 val funciona puesta marcha
19351L2NTBGLNDE92918AZDI6MZZONCEL MODULO DE ZONA CABLE MOTOR NO TIENE COMUNICACION CON LA CENTRALMódulo zona cable motor Airzone 32ZENVIAR UN MODULO DE ZONA NUEVOAZDI6MZZONC100.0AZDI6MZZONCModulo zona motor cable Airzone 32Z125195NoneEL MODULO DE ZONA CABLE MOTOR NO TIENE COMUNICACION CON LA CENTRAL Módulo zona cable motor Airzone 32Z ENVIAR UN MODULO DE ZONA NUEVOmodulo zona cable motor comunicacion central modulo zona cable motor airzone 32z enviar modulo zona
19352N2NXAWVJA892948AZCE6FLEXA3La placa central viene averiada. Según hemos visto por fuera parece como de haber sido usada ya que viene pintada, (aunque la caja venia precintada)\r\nTras hablar con el servicio tecnico de airzone nos dieron este codigo 240403168 para tramitar la garantia.CENT.AIRZONE FLEXA 3.0 6Z AZCE6FLEXA3necesitamos tramitar la garantia de la central Airzone que os compramos. La placa central viene averiada. Según hemos visto por fuera parece como de haber sido usada ya que viene pintada, (aunque la caja venia precintada)\r\nTras hablar con el serviciAZCE6FLEXA3100.0AZCE6FLEXA3Central de sistema Airzone Flexa 3.0 6Z125090NoneLa placa central viene averiada. Según hemos visto por fuera parece como de haber sido usada ya que viene pintada, (aunque la caja venia precintada)\r\nTras hablar con el servicio tecnico de airzone nos dieron este codigo 240403168 para tramitar la garantia. CENT.AIRZONE FLEXA 3.0 6Z AZCE6FLEXA3 necesitamos tramitar la garantia de la central Airzone que os compramos. La placa central viene averiada. Según hemos visto por fuera parece como de haber sido usada ya que viene pintada, (aunque la caja venia precintada)\r\nTras hablar con el serviciplaca central viene averiada visto usada viene pintada caja venia precintada hablar servicio tecnico airzone codigo 240403168 tramitar garantia cent.airzone flexa 3.0 6z azce6flexa3 necesitamos tramitar garantia central airzone compramos placa central viene averiada visto usada viene pintada caja venia precintada hablar servici
19353MGLWAWVH2692962AZCE6CB1MOTSEGÚN CONVERSACIÓN CON CLIENTEFLEXIÓN CENTRAL 3.0SEGÚN CONVERSACIÓN CON CLIENTEAZCE8CB1MOT91.0AZCE8CB1MOTCentral de sistema Airzone Flexa 4.0 (CE8)127090NoneSEGÚN CONVERSACIÓN CON CLIENTE FLEXIÓN CENTRAL 3.0 SEGÚN CONVERSACIÓN CON CLIENTEconversacion cliente flexion central 3.0 conversacion cliente
19354MWLVZMNQFD92992AZDI6OUTPUT8NoneMODULO CTROL.ELEM.RADIANTE 32 Z.AIRZONE (AZDI6OUTP*AZDI6OUTPUT8100.0AZDI6OUTPUT8Modulo control elementos radiantes Airzone 32Z125194NoneMODULO CTROL.ELEM.RADIANTE 32 Z.AIRZONE (AZDI6OUTP *modulo ctrol.elem.radiante 32 z.airzone azdi6outp
19355MWLVZMNQFD92993AZDI6MZZONCNoneMODULO ZONIFICACION 32 ZONAS CABLE (AZDI6MZZONC)*AZDI6MZZONC100.0AZDI6MZZONCModulo zona motor cable Airzone 32Z125195NoneMODULO ZONIFICACION 32 ZONAS CABLE (AZDI6MZZONC) *modulo zonificacion 32 zonas cable azdi6mzzonc
19356MWRUZ2LL6692996AZX6WEBSCLOUDCWEBSERVER NO FUNCIONASERVIDOR WEBWEBSERVER NO FUNCIONA. REVISADO POR SAT TELEFONICO.AZX6WEBSCLOUDC100.0AZX6WEBSCLOUDCWebserver Airzone cloud cable ethernet126093NoneWEBSERVER NO FUNCIONA SERVIDOR WEB WEBSERVER NO FUNCIONA. REVISADO POR SAT TELEFONICO.webserver funciona servidor web webserver funciona revisado sat telefonico
19357MGHUZGPLFB93097MINT / AZPV0MOTRDEVOLUCION MATERIAL EN GARANTIAMOTOR INTELIGENTE DOBLEREPOSICION EN GARANTIAMINT100.0MINTMotor de rejilla inteligente doble - sustituido por AZPV0MOTRMD126480NoneDEVOLUCION MATERIAL EN GARANTIA MOTOR INTELIGENTE DOBLE REPOSICION EN GARANTIAdevolucion material garantia motor inteligente doble reposicion garantia
19358MGHUZGPLFB93099MINT / AZPV0MOTRDEVOLUCION MATERIAL EN GARANTIAMOTOR INTELIGENTE DOBLEREPOSICION EN GARANTIAMINT100.0MINTMotor de rejilla inteligente doble - sustituido por AZPV0MOTRMD126480NoneDEVOLUCION MATERIAL EN GARANTIA MOTOR INTELIGENTE DOBLE REPOSICION EN GARANTIAdevolucion material garantia motor inteligente doble reposicion garantia